** Author: Molly Ariotti
** Project: Government Type and Public Spending in Africa
** Date: 2021-02-14


* Revise file location
use "/Users/molly/Dropbox/Institutions/Research/Spending/LSQ final submission/Replication/AfricanSpendingRR2.dta"

* Appendix B, Figure 1: number of ministers/country over time
xtline total_min_port, i(country) t(year) scheme(s1mono)


* Figure 1 manuscript: subset so it only uses data for the DV in question (ne_con_govt_zs).
drop if ne_con_govt_zs ==.

gen yearcat =.
replace yearcat =1 if year >= 1990 & year < 1995
replace yearcat =2 if year >= 1995 & year < 2000
replace yearcat =3 if year >= 2000 & year < 2005
replace yearcat =4 if year >= 2005 & year < 2010
replace yearcat =5 if year >= 2010 & year < 2015
replace yearcat =6 if year >= 2015
graph box total_min_port, over(yearcat) scheme(s1mono)
